package com.ztesoft.web.baseconfig.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class DmPlanRelationArg {
    private String pk_name = "DM_PLAN_ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<DmPlanRelationCriteria> oredCriteria;

    public DmPlanRelationArg() {
        oredCriteria = new ArrayList<DmPlanRelationCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<DmPlanRelationCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(DmPlanRelationCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public DmPlanRelationCriteria or() {
    	DmPlanRelationCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DmPlanRelationCriteria createCriteria() {
    	DmPlanRelationCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected DmPlanRelationCriteria createCriteriaInternal() {
    	DmPlanRelationCriteria criteria = new DmPlanRelationCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<DmPlanRelationCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<DmPlanRelationCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<DmPlanRelationCriterion> getAllCriteria() {
            return criteria;
        }

        public List<DmPlanRelationCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new DmPlanRelationCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmPlanRelationCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmPlanRelationCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new DmPlanRelationCriterion(condition, value1, value2));
        }

        public DmPlanRelationCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (DmPlanRelationCriteria) this;
        }
        public DmPlanRelationCriteria andDmPlanIdIsNull() {
            addCriterion("DM_PLAN_ID is null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdIsNotNull() {
            addCriterion("DM_PLAN_ID is not null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdEqualTo(Integer value) {
            addCriterion("DM_PLAN_ID =", value, "DM_PLAN_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdNotEqualTo(Integer value) {
            addCriterion("DM_PLAN_ID <>", value, "DM_PLAN_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdGreaterThan(Integer value) {
            addCriterion("DM_PLAN_ID >", value, "DM_PLAN_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DM_PLAN_ID >=", value, "DM_PLAN_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdLessThan(Integer value) {
            addCriterion("DM_PLAN_ID <", value, "DM_PLAN_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdLessThanOrEqualTo(Integer value) {
            addCriterion("DM_PLAN_ID <=", value, "DM_PLAN_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdLike(Integer value) {
            addCriterion("DM_PLAN_ID like ", value, "DM_PLAN_ID", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdNotLike(Integer value) {
            addCriterion("DM_PLAN_ID  not like ", value, "DM_PLAN_ID", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdLeftLike(Integer value) {
            addCriterion("DM_PLAN_ID like ", value, "DM_PLAN_ID", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdNotLeftLike(Integer value) {
            addCriterion("DM_PLAN_ID  not like ", value, "DM_PLAN_ID", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdRightLike(Integer value) {
            addCriterion("DM_PLAN_ID like ", value, "DM_PLAN_ID", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdNotRightLike(Integer value) {
            addCriterion("DM_PLAN_ID  not like ", value, "DM_PLAN_ID", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdIn(List<Integer> values) {
            addCriterion("DM_PLAN_ID  in ", values, "DM_PLAN_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdNotIn(List<Integer> values) {
            addCriterion("DM_PLAN_ID not in ", values, "DM_PLAN_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdBetween(Integer value1, Integer value2) {
            addCriterion("DM_PLAN_ID between ", value1, value2, "DM_PLAN_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmPlanIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DM_PLAN_ID not between ", value1, value2, "DM_PLAN_ID");
            return (DmPlanRelationCriteria) this;
        }
        public DmPlanRelationCriteria andSeqNbrIsNull() {
            addCriterion("SEQ_NBR is null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrIsNotNull() {
            addCriterion("SEQ_NBR is not null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrEqualTo(Integer value) {
            addCriterion("SEQ_NBR =", value, "SEQ_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrNotEqualTo(Integer value) {
            addCriterion("SEQ_NBR <>", value, "SEQ_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrGreaterThan(Integer value) {
            addCriterion("SEQ_NBR >", value, "SEQ_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrGreaterThanOrEqualTo(Integer value) {
            addCriterion("SEQ_NBR >=", value, "SEQ_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrLessThan(Integer value) {
            addCriterion("SEQ_NBR <", value, "SEQ_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrLessThanOrEqualTo(Integer value) {
            addCriterion("SEQ_NBR <=", value, "SEQ_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrNotLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrLeftLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrNotLeftLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrRightLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrNotRightLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrIn(List<Integer> values) {
            addCriterion("SEQ_NBR  in ", values, "SEQ_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrNotIn(List<Integer> values) {
            addCriterion("SEQ_NBR not in ", values, "SEQ_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrBetween(Integer value1, Integer value2) {
            addCriterion("SEQ_NBR between ", value1, value2, "SEQ_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andSeqNbrNotBetween(Integer value1, Integer value2) {
            addCriterion("SEQ_NBR not between ", value1, value2, "SEQ_NBR");
            return (DmPlanRelationCriteria) this;
        }
        public DmPlanRelationCriteria andDmStrategyIdIsNull() {
            addCriterion("DM_STRATEGY_ID is null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdIsNotNull() {
            addCriterion("DM_STRATEGY_ID is not null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdEqualTo(Integer value) {
            addCriterion("DM_STRATEGY_ID =", value, "DM_STRATEGY_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdNotEqualTo(Integer value) {
            addCriterion("DM_STRATEGY_ID <>", value, "DM_STRATEGY_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdGreaterThan(Integer value) {
            addCriterion("DM_STRATEGY_ID >", value, "DM_STRATEGY_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DM_STRATEGY_ID >=", value, "DM_STRATEGY_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdLessThan(Integer value) {
            addCriterion("DM_STRATEGY_ID <", value, "DM_STRATEGY_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdLessThanOrEqualTo(Integer value) {
            addCriterion("DM_STRATEGY_ID <=", value, "DM_STRATEGY_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdLike(Integer value) {
            addCriterion("DM_STRATEGY_ID like ", value, "DM_STRATEGY_ID", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdNotLike(Integer value) {
            addCriterion("DM_STRATEGY_ID  not like ", value, "DM_STRATEGY_ID", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdLeftLike(Integer value) {
            addCriterion("DM_STRATEGY_ID like ", value, "DM_STRATEGY_ID", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdNotLeftLike(Integer value) {
            addCriterion("DM_STRATEGY_ID  not like ", value, "DM_STRATEGY_ID", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdRightLike(Integer value) {
            addCriterion("DM_STRATEGY_ID like ", value, "DM_STRATEGY_ID", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdNotRightLike(Integer value) {
            addCriterion("DM_STRATEGY_ID  not like ", value, "DM_STRATEGY_ID", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdIn(List<Integer> values) {
            addCriterion("DM_STRATEGY_ID  in ", values, "DM_STRATEGY_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdNotIn(List<Integer> values) {
            addCriterion("DM_STRATEGY_ID not in ", values, "DM_STRATEGY_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdBetween(Integer value1, Integer value2) {
            addCriterion("DM_STRATEGY_ID between ", value1, value2, "DM_STRATEGY_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andDmStrategyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DM_STRATEGY_ID not between ", value1, value2, "DM_STRATEGY_ID");
            return (DmPlanRelationCriteria) this;
        }
        public DmPlanRelationCriteria andGroupNbrIsNull() {
            addCriterion("GROUP_NBR is null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrIsNotNull() {
            addCriterion("GROUP_NBR is not null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrEqualTo(Integer value) {
            addCriterion("GROUP_NBR =", value, "GROUP_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrNotEqualTo(Integer value) {
            addCriterion("GROUP_NBR <>", value, "GROUP_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrGreaterThan(Integer value) {
            addCriterion("GROUP_NBR >", value, "GROUP_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrGreaterThanOrEqualTo(Integer value) {
            addCriterion("GROUP_NBR >=", value, "GROUP_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrLessThan(Integer value) {
            addCriterion("GROUP_NBR <", value, "GROUP_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrLessThanOrEqualTo(Integer value) {
            addCriterion("GROUP_NBR <=", value, "GROUP_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrLike(Integer value) {
            addCriterion("GROUP_NBR like ", value, "GROUP_NBR", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrNotLike(Integer value) {
            addCriterion("GROUP_NBR  not like ", value, "GROUP_NBR", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrLeftLike(Integer value) {
            addCriterion("GROUP_NBR like ", value, "GROUP_NBR", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrNotLeftLike(Integer value) {
            addCriterion("GROUP_NBR  not like ", value, "GROUP_NBR", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrRightLike(Integer value) {
            addCriterion("GROUP_NBR like ", value, "GROUP_NBR", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrNotRightLike(Integer value) {
            addCriterion("GROUP_NBR  not like ", value, "GROUP_NBR", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrIn(List<Integer> values) {
            addCriterion("GROUP_NBR  in ", values, "GROUP_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrNotIn(List<Integer> values) {
            addCriterion("GROUP_NBR not in ", values, "GROUP_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrBetween(Integer value1, Integer value2) {
            addCriterion("GROUP_NBR between ", value1, value2, "GROUP_NBR");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andGroupNbrNotBetween(Integer value1, Integer value2) {
            addCriterion("GROUP_NBR not between ", value1, value2, "GROUP_NBR");
            return (DmPlanRelationCriteria) this;
        }
        public DmPlanRelationCriteria andExecOrderIsNull() {
            addCriterion("EXEC_ORDER is null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderIsNotNull() {
            addCriterion("EXEC_ORDER is not null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderEqualTo(Integer value) {
            addCriterion("EXEC_ORDER =", value, "EXEC_ORDER");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderNotEqualTo(Integer value) {
            addCriterion("EXEC_ORDER <>", value, "EXEC_ORDER");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderGreaterThan(Integer value) {
            addCriterion("EXEC_ORDER >", value, "EXEC_ORDER");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderGreaterThanOrEqualTo(Integer value) {
            addCriterion("EXEC_ORDER >=", value, "EXEC_ORDER");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderLessThan(Integer value) {
            addCriterion("EXEC_ORDER <", value, "EXEC_ORDER");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderLessThanOrEqualTo(Integer value) {
            addCriterion("EXEC_ORDER <=", value, "EXEC_ORDER");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderLike(Integer value) {
            addCriterion("EXEC_ORDER like ", value, "EXEC_ORDER", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderNotLike(Integer value) {
            addCriterion("EXEC_ORDER  not like ", value, "EXEC_ORDER", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderLeftLike(Integer value) {
            addCriterion("EXEC_ORDER like ", value, "EXEC_ORDER", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderNotLeftLike(Integer value) {
            addCriterion("EXEC_ORDER  not like ", value, "EXEC_ORDER", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderRightLike(Integer value) {
            addCriterion("EXEC_ORDER like ", value, "EXEC_ORDER", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderNotRightLike(Integer value) {
            addCriterion("EXEC_ORDER  not like ", value, "EXEC_ORDER", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderIn(List<Integer> values) {
            addCriterion("EXEC_ORDER  in ", values, "EXEC_ORDER");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderNotIn(List<Integer> values) {
            addCriterion("EXEC_ORDER not in ", values, "EXEC_ORDER");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderBetween(Integer value1, Integer value2) {
            addCriterion("EXEC_ORDER between ", value1, value2, "EXEC_ORDER");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExecOrderNotBetween(Integer value1, Integer value2) {
            addCriterion("EXEC_ORDER not between ", value1, value2, "EXEC_ORDER");
            return (DmPlanRelationCriteria) this;
        }
        public DmPlanRelationCriteria andEffDateIsNull() {
            addCriterion("EFF_DATE is null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateIsNotNull() {
            addCriterion("EFF_DATE is not null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateEqualTo(String value) {
            addCriterion("EFF_DATE =", value, "EFF_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateNotEqualTo(String value) {
            addCriterion("EFF_DATE <>", value, "EFF_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateGreaterThan(String value) {
            addCriterion("EFF_DATE >", value, "EFF_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateGreaterThanOrEqualTo(String value) {
            addCriterion("EFF_DATE >=", value, "EFF_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateLessThan(String value) {
            addCriterion("EFF_DATE <", value, "EFF_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateLessThanOrEqualTo(String value) {
            addCriterion("EFF_DATE <=", value, "EFF_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateLike(String value) {
            addCriterion("EFF_DATE like ", value, "EFF_DATE", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateNotLike(String value) {
            addCriterion("EFF_DATE  not like ", value, "EFF_DATE", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateLeftLike(String value) {
            addCriterion("EFF_DATE like ", value, "EFF_DATE", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateNotLeftLike(String value) {
            addCriterion("EFF_DATE  not like ", value, "EFF_DATE", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateRightLike(String value) {
            addCriterion("EFF_DATE like ", value, "EFF_DATE", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateNotRightLike(String value) {
            addCriterion("EFF_DATE  not like ", value, "EFF_DATE", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateIn(List<String> values) {
            addCriterion("EFF_DATE  in ", values, "EFF_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateNotIn(List<String> values) {
            addCriterion("EFF_DATE not in ", values, "EFF_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateBetween(String value1, String value2) {
            addCriterion("EFF_DATE between ", value1, value2, "EFF_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andEffDateNotBetween(String value1, String value2) {
            addCriterion("EFF_DATE not between ", value1, value2, "EFF_DATE");
            return (DmPlanRelationCriteria) this;
        }
        public DmPlanRelationCriteria andExpDateIsNull() {
            addCriterion("EXP_DATE is null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateIsNotNull() {
            addCriterion("EXP_DATE is not null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateEqualTo(String value) {
            addCriterion("EXP_DATE =", value, "EXP_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateNotEqualTo(String value) {
            addCriterion("EXP_DATE <>", value, "EXP_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateGreaterThan(String value) {
            addCriterion("EXP_DATE >", value, "EXP_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateGreaterThanOrEqualTo(String value) {
            addCriterion("EXP_DATE >=", value, "EXP_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateLessThan(String value) {
            addCriterion("EXP_DATE <", value, "EXP_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateLessThanOrEqualTo(String value) {
            addCriterion("EXP_DATE <=", value, "EXP_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateLike(String value) {
            addCriterion("EXP_DATE like ", value, "EXP_DATE", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateNotLike(String value) {
            addCriterion("EXP_DATE  not like ", value, "EXP_DATE", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateLeftLike(String value) {
            addCriterion("EXP_DATE like ", value, "EXP_DATE", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateNotLeftLike(String value) {
            addCriterion("EXP_DATE  not like ", value, "EXP_DATE", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateRightLike(String value) {
            addCriterion("EXP_DATE like ", value, "EXP_DATE", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateNotRightLike(String value) {
            addCriterion("EXP_DATE  not like ", value, "EXP_DATE", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateIn(List<String> values) {
            addCriterion("EXP_DATE  in ", values, "EXP_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateNotIn(List<String> values) {
            addCriterion("EXP_DATE not in ", values, "EXP_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateBetween(String value1, String value2) {
            addCriterion("EXP_DATE between ", value1, value2, "EXP_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andExpDateNotBetween(String value1, String value2) {
            addCriterion("EXP_DATE not between ", value1, value2, "EXP_DATE");
            return (DmPlanRelationCriteria) this;
        }
        public DmPlanRelationCriteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateEqualTo(String value) {
            addCriterion("CREATE_DATE =", value, "CREATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateNotEqualTo(String value) {
            addCriterion("CREATE_DATE <>", value, "CREATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateGreaterThan(String value) {
            addCriterion("CREATE_DATE >", value, "CREATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE >=", value, "CREATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateLessThan(String value) {
            addCriterion("CREATE_DATE <", value, "CREATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateLessThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE <=", value, "CREATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateNotLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateLeftLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateNotLeftLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateRightLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateNotRightLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateIn(List<String> values) {
            addCriterion("CREATE_DATE  in ", values, "CREATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateNotIn(List<String> values) {
            addCriterion("CREATE_DATE not in ", values, "CREATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateBetween(String value1, String value2) {
            addCriterion("CREATE_DATE between ", value1, value2, "CREATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andCreateDateNotBetween(String value1, String value2) {
            addCriterion("CREATE_DATE not between ", value1, value2, "CREATE_DATE");
            return (DmPlanRelationCriteria) this;
        }
        public DmPlanRelationCriteria andStateIsNull() {
            addCriterion("STATE is null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "STATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "STATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "STATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "STATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "STATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "STATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateLike(String value) {
            addCriterion("STATE like ", value, "STATE", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateNotLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateLeftLike(String value) {
            addCriterion("STATE like ", value, "STATE", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateNotLeftLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateRightLike(String value) {
            addCriterion("STATE like ", value, "STATE", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateNotRightLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateIn(List<String> values) {
            addCriterion("STATE  in ", values, "STATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in ", values, "STATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between ", value1, value2, "STATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between ", value1, value2, "STATE");
            return (DmPlanRelationCriteria) this;
        }
        public DmPlanRelationCriteria andStateDateIsNull() {
            addCriterion("STATE_DATE is null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateIsNotNull() {
            addCriterion("STATE_DATE is not null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateEqualTo(String value) {
            addCriterion("STATE_DATE =", value, "STATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateNotEqualTo(String value) {
            addCriterion("STATE_DATE <>", value, "STATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateGreaterThan(String value) {
            addCriterion("STATE_DATE >", value, "STATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE_DATE >=", value, "STATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateLessThan(String value) {
            addCriterion("STATE_DATE <", value, "STATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateLessThanOrEqualTo(String value) {
            addCriterion("STATE_DATE <=", value, "STATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateNotLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateLeftLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateNotLeftLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateRightLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateNotRightLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateIn(List<String> values) {
            addCriterion("STATE_DATE  in ", values, "STATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateNotIn(List<String> values) {
            addCriterion("STATE_DATE not in ", values, "STATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateBetween(String value1, String value2) {
            addCriterion("STATE_DATE between ", value1, value2, "STATE_DATE");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStateDateNotBetween(String value1, String value2) {
            addCriterion("STATE_DATE not between ", value1, value2, "STATE_DATE");
            return (DmPlanRelationCriteria) this;
        }
        public DmPlanRelationCriteria andStaffIdIsNull() {
            addCriterion("STAFF_ID is null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdIsNotNull() {
            addCriterion("STAFF_ID is not null");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdEqualTo(Integer value) {
            addCriterion("STAFF_ID =", value, "STAFF_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdNotEqualTo(Integer value) {
            addCriterion("STAFF_ID <>", value, "STAFF_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdGreaterThan(Integer value) {
            addCriterion("STAFF_ID >", value, "STAFF_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("STAFF_ID >=", value, "STAFF_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdLessThan(Integer value) {
            addCriterion("STAFF_ID <", value, "STAFF_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdLessThanOrEqualTo(Integer value) {
            addCriterion("STAFF_ID <=", value, "STAFF_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdNotLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 1);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdLeftLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdNotLeftLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 0);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdRightLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdNotRightLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 2);
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdIn(List<Integer> values) {
            addCriterion("STAFF_ID  in ", values, "STAFF_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdNotIn(List<Integer> values) {
            addCriterion("STAFF_ID not in ", values, "STAFF_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdBetween(Integer value1, Integer value2) {
            addCriterion("STAFF_ID between ", value1, value2, "STAFF_ID");
            return (DmPlanRelationCriteria) this;
        }

        public DmPlanRelationCriteria andStaffIdNotBetween(Integer value1, Integer value2) {
            addCriterion("STAFF_ID not between ", value1, value2, "STAFF_ID");
            return (DmPlanRelationCriteria) this;
        }

    }

    public static class DmPlanRelationCriteria extends GeneratedCriteria {

        protected DmPlanRelationCriteria() {
            super();
        }
    }

    public static class DmPlanRelationCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected DmPlanRelationCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected DmPlanRelationCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected DmPlanRelationCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected DmPlanRelationCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected DmPlanRelationCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected DmPlanRelationCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}